New Orleans Restaurants

Step 1: Access Restaurant Data

from sodapy import Socrata
import pandas as pd
import json
api_url = "data.nola.gov"
resource = "hjcd-grvu"
client = Socrata(api_url, None)
results = client.get(resource, limit = 50000)
restaurants = [item for item in results if (item['businesstype'] == '1105 - FULL SVC RESTAURANTS (TABLE SERVICE)' or item['businesstype'] == '2062 - LIMITED SVC RESTAURANTS(NO TABLE SVC)' or item['businesstype'] == '1126 - DRINKING PLACES (ALCOHOLIC BEVERAGES)'   )]
businesses_json = json.dumps(results, indent=4)
with open("businesses.json", "w") as outfile:
  outfile.write(businesses_json)

json = json.dumps(restaurants, indent=4)
with open("restaurants.json", "w") as outfile:
  outfile.write(json)

Step 2: Access Neighborhood Data

import pandas as pd
import requests
import json
api_url = "https://maps.nola.gov/server/rest/services/Reference/Reference_Layers/MapServer/0/query?where=OBJECTID%3E0&outFields=*&returnGeometry=true&f=geojson"
results = requests.get(api_url)
with open("neighborhoods.geojson", "w") as outfile:
  outfile.write(results.content.decode('utf-8'))

Step 3: Map Neighborhoods with Leaflet

from sodapy import Socrata
import json
import pandas as pd
import geopandas as gpd
from ipyleaflet import Map, basemaps, basemap_to_tiles, GeoData, LayersControl

df = gpd.read_file("neighborhoods.geojson")
df.plot()
geo_data = GeoData(
   geo_dataframe = df,
   name = 'Neighborhoods'
)
m = Map(center=(30.204793, -90.000000), zoom=9)
tiles = basemap_to_tiles(basemaps.CartoDB.Voyager)
m.add_layer(geo_data)
m

Step 4: Map Restaurants with Leaflet

import json
import pandas as pd
import geopandas as gpd
from ipyleaflet import Map, basemaps, basemap_to_tiles, GeoData, LayersControl
with open('restaurants.json') as file:
  restaurants_json = json.load(file)

rdf = pd.DataFrame(restaurants_json)
restaurants = gpd.GeoDataFrame(rdf, geometry=gpd.points_from_xy(rdf.longitude,rdf.latitude),crs="EPSG:4326")
restaurants.plot()
geo_data = GeoData(
   geo_dataframe = restaurants,
   style={'color': 'black', 'fillColor': '#3366cc', 'opacity':0.05, 'weight':1.9, 'dashArray':'2', 'fillOpacity':0.6},
   hover_style={'fillColor': 'red' , 'fillOpacity': 0.2},
   name = 'Restaurants'
)
m = Map(center=(30.204793, -90.000000), zoom=9)
tiles = basemap_to_tiles(basemaps.CartoDB.Voyager)
m.add_layer(geo_data)
m

from IPython.display import display, HTML
with open('businesses.json') as file:
  businesses_json = json.load(file)

df = pd.DataFrame(businesses_json)
display(HTML(df.head().to_html()))
a = pd.DataFrame(df.groupby('businesstype').size().sort_values(ascending=False))
display(HTML(a.to_html()))

	businessname	ownername	businesstype	businesslicensenumber	businessstartdate	address	streetnumber	streetname	streetsuffix	city	state	zip	mailaddress	mailcity	mailstate	mailzip	latitude	longitude	location	:@computed_region_ewbu_t8bu	:@computed_region_k37d_then	:@computed_region_m56f_hbma	:@computed_region_7fw3_kdpf	:@computed_region_spev_d8jm	:@computed_region_sikx_bdeb	:@computed_region_evki_aju8	:@computed_region_u4yh_3wk9	suite	mailsuite	streetdirection	phonenumber
0	1000 FIGS	THE SUNNY KITCHEN,LLC	1105 - FULL SVC RESTAURANTS (TABLE SERVICE)	304684	2014-11-08T00:00:00.000	3141 PONCE DE LEON ST	3141	PONCE DE LEON	ST	NEW ORLEANS	LA	70119	261 ACOMA ST	DENVER	CO	80223	29.9805170951699	-90.0842403014248	{'latitude': '29.9805170951699', 'longitude': '-90.0842403014248', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	12981	1	91	21	3768	91	6	12981	NaN	NaN	NaN	NaN
1	1040, INC	1040, INC	3347 - TAX PREPARATION SERVICES	276137	2015-01-20T00:00:00.000	6000 BULLARD AVE	6000	BULLARD	AVE	NEW ORLEANS	LA	70126	6000 BULLARD AVE	NEW ORLEANS	LA	70126	30.043422170192	-89.9614578795639	{'latitude': '30.043422170192', 'longitude': '-89.9614578795639', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	5372	5	188	54	4150	188	1	5372	NaN	NaN	NaN	NaN
2	1040, INC	DBA JACKSON HEWITT TAX SERVICE	3347 - TAX PREPARATION SERVICES	295326	2019-01-18T00:00:00.000	5941 BULLARD AVE	5941	BULLARD	AVE	NEW ORLEANS	LA	70128	5941 BULLARD AVE	NEW ORLEANS	LA	70128	30.040876283326	-89.9551160763878	{'latitude': '30.040876283326', 'longitude': '-89.9551160763878', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	1100	5	188	54	4150	188	1	1100	3	3	NaN	NaN
3	105 SEAHORSES LLC	105 SEAHORSES LLC	2052 - INDEPENDENT ARTISTS/WRITERS/PERFORMERS	292668	2022-08-18T00:00:00.000	601 S SCOTT ST	601	SCOTT	ST	NEW ORLEANS	LA	70119	601 S SCOTT ST	NEW ORLEANS	LA	70119	29.9688144964553	-90.1025632674974	{'latitude': '29.9688144964553', 'longitude': '-90.1025632674974', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	8776	2	109	47	3768	109	6	8776	NaN	NaN	S	NaN
4	11.22	11.22 LLC	1105 - FULL SVC RESTAURANTS (TABLE SERVICE)	295104	2022-04-01T00:00:00.000	8480 MORRISON RD	8480	MORRISON	RD	NEW ORLEANS	LA	70127	1763 JACKSON AVE	NEW ORLEANS	LA	70113	30.0359895647335	-89.994419375814	{'latitude': '30.0359895647335', 'longitude': '-89.994419375814', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	13795	5	166	20	4149	166	1	13795	B	NaN	NaN	5042899128

	0
businesstype
1105 - FULL SVC RESTAURANTS (TABLE SERVICE)	879
2001 - TAXI SERVICE	495
1126 - DRINKING PLACES (ALCOHOLIC BEVERAGES)	399
1203 - ARTIST-PAINTING ON STREETS	305
3382 - LAWYERS	304
1212 - HOME BASED-OFFICE USE ONLY	298
2062 - LIMITED SVC RESTAURANTS(NO TABLE SVC)	273
0151 - FLEA MARKET	269
4701 - HOTELS (EXC CASINO HOTELS) & MOTELS	230
3338 - BEAUTY SALONS	212
1185 - SPECIAL TRADE CONTRACTORS, ALL OTHER	187
1169 - MISC STORE RTLERS (EX TOBAC), ALL OTH	186
2014 - PARKING LOTS & GARAGES	171
1101 - CONVENIENCE STORES	163
3803 - PERSONAL SERVICES, ALL OTHER	157
1173 - ART DEALERS	157
1119 - GENERAL MERCHANDISE STORES, ALL OTH	156
3361 - OFFICE OF PHYSICIAN(EX MENTAL HEALTH)	139
3401 - ELECTRICAL CONTRACTORS	122
3350 - ADMIN MGT/GENERAL MGT CONSULTING SVCS	119
2003 - LIMOUSINE SERVICE	116
1128 - CLOTHING STORES, OTHER	113
1106 - GROCERY (EXC CONVENIENCE) STORES	111
1401 - SOCIAL ADVOCACY ORGANIZATIONS, OTHER	101
4703 - BED & BREAKFAST INNS	99
1204 - MARDI GRAS - FIXED LOCATIONS	93
2081 - NAIL SALONS	89
3366 - CHILD DAY CARE SERVICES	88
1154 - GIFT, NOVELTY & SOUVENIR STORES	87
4511 - VIDEO DRAW POKER DEVICES	86
0178 - OFFICES OF DENTISTS	82
4001 - MGMT CONSULTING SVCS, OTHER	78
5301 - TOUR OPERATORS	77
3353 - ARCHITECTURAL SERVICES	77
3307 - BARBER SHOPS	76
2065 - CATERERS	75
0182 - OFFICES OF MENTAL HEALTH PRACTIT, OTH	73
0802 - PLUMBING, HEATING & A/C CONTRACTORS	72
0501 - REAL ESTATE AGENTS AND BROKERS	69
1120 - PHARMACIES & DRUG STORES	69
1121 - COSMETICS/BEAUTY SUPP/PERFUME STORES	69
3355 - ENGINEERING SERVICES	67
1131 - GASOLINE STATIONS W/CONVENIENCE STORES	66
1114 - WOMEN'S CLOTHING STORES	66
3373 - PERSONAL CARE SERVICES, OTHER	66
3305 - LESSOR OF RESIDENTIAL BLDGS/DWELLINGS	66
3203 - INTERIOR DESIGN SERVICES	66
5502 - MOBILE FOOD SERVICES	65
1160 - ELECTRONIC SHOPPING/MAIL-ORDER HOUSES	63
3312 - FOOD SERVICE CONTRACTORS	63
3310 - REAL ESTATE, OTHER ACTIVITIES RELATED	60
2004 - TRANSIT/GROUND PASSNGR TRANS, ALL OTH	60
1122 - JEWELRY STORES	59
4901 - CIVIC & SOCIAL ORGANIZATIONS	58
3334 - FITNESS & RECREATIONAL SPORTS CTRS	54
0185 - OFFICES OF HEALTH PRACT, ALL OTH MISC	54
2033 - JANITORIAL SERVICES	51
1134 - FURNITURE STORES	50
2025 - LANDSCAPING SERVICES	50
1112 - CLOTHING ACCESSORIES STORES	47
2071 - AUTO REPAIR & MAINT, ALL OTH	47
3375 - CELLULAR & OTH WIRELESS TELECOMM	46
3336 - ACCOUNTING SERVICES, OTHER	45
0315 - COMMERCIAL/INSTITUTIONAL BLDG CONSTRU	44
1108 - BAKED GOODS STORES	44
3501 - SINGLE FAMILY HOUSING CONSTRUCTION	41
2019 - COIN-OPERATED LAUNDRIES/DRY CLEANERS	41
2064 - SNACK & NONALCOHOLIC BEVERAGE BARS	40
3347 - TAX PREPARATION SERVICES	39
2032 - SPECIAL NEEDS TRANSPORTATION	36
3802 - SECURITY GUARDS & PATROL SERVICES	36
2002 - GENERAL AUTOMOTIVE REPAIR	36
2015 - GENERAL WAREHOUSING & STORAGE	36
1117 - FAMILY CLOTHING STORES	35
0177 - OFF OF PHYSICIAN, MNTL HLTH SPECIALST	35
0174 - SCHOOLS & INSTRUCTION, ALL OTH MISC	35
1129 - AUTO PARTS & ACCESSORIES STORES	35
0175 - EDUCATIONAL SUPPORT SERVICES	34
2094 - OFFICE ADMINISTRATIVE SERVICES	34
1149 - TOBACCO STORES	34
2010 - MOTOR VEHICLE TOWING	34
3002 - LESSOR OF NONRES BLDGS (EX MINIWRHSE)	33
1191 - HOME FURNISHINGS STORES, ALL OTH	33
3342 - LEGAL SERVICES, ALL OTHER	32
1501 - DURABLE GOODS WHLSRS, OTHER MISC	32
1145 - BOOK STORES	31
2052 - INDEPENDENT ARTISTS/WRITERS/PERFORMERS	31
0183 - PHYS/OCCUP/SPEECH THERAP/AUDIOLOGISTS	30
3380 - MARKETING CONSULTING SVCS	29
2023 - CAR WASHES	27
1109 - CONFECTIONERY & NUT STORES	27
3364 - RECEPTION HALL	27
4201 - SCIENTIFIC/TECHNCL CONSLTNG SVCS, OTH	27
2501 - MUSEUMS	26
1110 - BEER, WINE & LIQUOR STORES	26
2068 - AUTO MECHANICAL/ELECTRICAL R & M, OTH	26
0164 - ELEMENTARY & SECONDARY SCHOOLS	26
0176 - HOME HEALTH CARE SVCS	26
2031 - AUTOMOTIVE BODY, PAINT & INTERIOR R&M	25
4509 - VETERINARY SVCS	25
1170 - CARPENTRY CONTRACTORS	25
1115 - SHOE STORES	25
1205 - MARDI GRAS - WALKERS	25
3202 - PHOTOGRAPHY STUDIOS, PORTRAIT	24
3308 - LESSORS OF OTH REAL ESTATE PROPERTY	24
1155 - HEALTH/PERSONAL CARE STORES, ALL OTH	24
3344 - CERTIFIED PUBLIC ACCOUNTANTS	23
3352 - INVESTMENT ADVICE	23
3207 - MOTION PICTURE & VIDEO PRODUCTION	23
0180 - OFFICES OF CHIROPRACTORS	23
3369 - GRAPHIC DESIGN SVCS	22
1111 - SPECIALTY FOOD STORES, ALL OTHER	22
1140 - BUILDING MATERIAL DEALERS, OTHER	22
2029 - GENERAL FREIGHT TRUCKING	21
1157 - USED MERCHANDISE STORES	21
0502 - RESIDENTIAL PROPERTY MGRS	21
4502 - COIN-OPER AMUSEMENT DEVICES, ALL OTH	21
3345 - PROF/SCIENTIFIC/TECHNCL SVCS, ALL OTH	20
1151 - FLORISTS	20
2018 - DRY-CLEAN/LAUNDRY SVCS (EXC COIN-OP)	20
0190 - OUTPATIENT CARE CENTERS, ALL OTH	20
3901 - EMPLOYMENT PLACEMENT AGENCIES	20
3346 - TRAVEL ARRNGMNT/RESERVN SVCS, ALL OTH	19
3383 - GENERAL MEDICAL & SURGICAL HOSPITALS	19
1113 - MEN'S CLOTHING STORES	19
3001 - PASSENGER CAR RENTAL	19
1130 - TIRE DEALERS	18
2901 - FUNERAL HOMES & FUNERAL SERVICES	18
1001 - CONSUMER LENDING	18
1166 - PERSONAL & HH GOODS R & M, OTHER	18
0188 - KIDNEY DIALYSIS CENTERS	18
3801 - INVESTIGATION SERVICES	18
2039 - CHILD & YOUTH SVCS	18
5503 - DIRECT SELLING ESTABLISHMENTS, OTH	17
0150 - NONDURABLE GOODS WHLSRS, OTH MISC	17
3101 - INSURANCE AGENCIES & BROKERAGES	17
1199 - PET & PET SUPPLIES STORES	17
1189 - RADIO, TV & OTH ELECTRONICS STORES	17
3337 - COMMER/IND MACH & EQP RNTL/LSNG, OTH	17
3374 - COMPUTER SYSTEMS DESIGN SVCS	17
1602 - USED CAR DEALERS	17
4506 - COMMERCIAL PHOTOGRAPHY	16
4002 - ENVIRONMENTAL CONSULTING SVCS	15
2063 - CAFETERIAS	15
3309 - NONRESIDENTIAL PROPERTY MANAGERS	15
3201 - SPECIALIZED DESIGN SERVICES, OTHER	15
2051 - PROM OF PERFORM ARTS/SPORTS/SIM EVNTS	15
0607 - HEAVY CONSTRUCTION, ALL OTHER	15
0144 - WINE/DISTILLED ALCOHOLIC BEV WHLSRS	15
0181 - OFFICES OF OPTOMETRISTS	15
1143 - OPTICAL GOODS STORES	15
0187 - OUTPATIENT MENTL HLTH/SUBS ABUSE CTRS	14
1174 - BOAT DEALERS/MARINE SUPPLIES	14
3304 - PET CARE (EXC VETERINARIAN) SERVICES	14
3333 - INSURANCE RELATED ACTIVITIES, ALL OTHER	14
2041 - INDIVIDUAL & FAMILY SERVICES, OTH	14
1123 - SPORTING GOODS STORES	14
2310 - AMUSEMENT/RECREATION INDUST, ALL OTH	14
0108 - ELECTRIC PARTS & EQUIP WHLSRS, OTH	13
1104 - FISH & SEAFOOD MARKETS	13
1176 - ROOFING/SIDING/SHEET METAL CONTRACTOR	13
3371 - TECHNICAL & TRADE SCHOOLS, OTHER	13
3341 - TITLE ABSTRACT & SETTLEMENT OFFICES	13
2802 - BREWERIES	13
1502 - CONSTRUCTION MATERIAL WHLSRS, OTHER	12
3379 - PUBLIC RELATIONS AGENCIES	12
0116 - INDUSTRIAL SUPPLIES WHLSRS	12
3372 - CUSTOM COMPUTER PROGRAMMING SVCS	12
2404 - DANCE COMPANIES	12
1127 - SEWING/NEEDLEWORK/PIECE GOODS STORES	12
1116 - CHILDREN'S & INFANTS' CLOTHING STORES	12
5501 - SECURITY SYSTEMS SVCS (EX LOCKSMITHS)	12
3324 - CONSUMER GOODS RENTAL, ALL OTHER	11
3701 - ADVERTISING AGENCIES	11
3314 - TRUCK/UTILITY TRAILER/RV RNTL & LSNG	11
1607 - COFFEE & TEA MFG	11
0202 - INVESTMENT BANKING	11
1146 - BUS SVC CENTRS (INCL COPY SHOPS), OTH	11
4702 - ROOMING & BOARDING HOUSES	11
2005 - CHARTER BUS INDUSTRY	11
0313 - MULTIFAMILY HOUSING CONSTRUCTION	10
2027 - SUPPORT SERVICES, ALL OTHER	10
3365 - FINE ARTS SCHOOLS	10
1177 - CONCRETE CONTRACTORS	10
0102 - ALL OTH MISC MFG	10
0135 - FISH & SEAFOOD WHLSRS	10
3340 - TRAVEL AGENCIES	10
1003 - IN OPERATION-PENDING RTN OF RV FORM	10
0026 - COMMERCIAL PRINTING	10
2079 - REUPHOLSTERY & FURN REPAIR	10
2085 - PAY DAY LOANS	10
3326 - GENERAL RENTAL CENTERS	10
1137 - COMPUTER & SOFTWARE STORES	10
3325 - SPORTS & RECREATION INSTRUCTION	9
2021 - WASTE MGMT, ALL OTHER MISC	9
3317 - VIDEO TAPE & DISK RENTAL	9
2059 - MARINAS	9
3306 - LESSOR OF MINIWRHSE/SELF STORAGE UNITS	9
1707 - LMBR/PLYWD/MILLWORK/WORK PANEL WHLSRS	9
3204 - RELIGIOUS ORG	9
2302 - THEATER CO & DINNER THEATERS	9
1701 - AUTO & OTH MOTOR VEHICLE WHLSRS	9
2017 - SCENIC & SIGHTSEEING TRANS, LAND	9
0306 - SECURITIES BROKERAGE	9
0138 - GROCERY & RELATED PRDCTS WHLSRS, OTH	9
3378 - HUMAN RESOURC/EXEC SRCH CNSLTING SVCS	9
1124 - NURSERY & GARDEN CENTERS	9
0195 - AMBULTRY HLTH CARE SVCS, ALL OTH MISC	9
5508 - CONVENTION & TRADE SHOW ORGANIZERS	9
1164 - PAINTING & WALL COVERING CONTRACTORS	9
1147 - MUSICAL INSTRUMENT & SUPPLIES STORES	8
1142 - GASOLINE STATIONS, OTHER	8
1139 - PAINT & WALLPAPER STORES	8
1187 - HOBBY, TOY & GAME STORES	8
2047 - MUSICAL GROUPS & ARTISTS	8
2044 - COMMUNITY HOUSING SVCS, OTH	8
3327 - SIMLR ORG (EX BUS/PROF/LABOR/POL), OTH	8
1153 - CEMETERIES & CREMATORIES	8
3322 - RECREATIONAL GOODS RENTAL	8
2040 - SVCS FOR ELDERLY & DISABLED PERSONS	8
1103 - MEAT MARKETS	8
3318 - TESTING LABORATORIES	8
0199 - RESID MENTAL HLTH/SUBST ABUSE FACILIT	8
0304 - COMMISSION AGENTS/BROKERS	8
0191 - MEDICAL LAB	8
0305 - FNAN TRANSAC PROC/RESRV/CLEARGHSE ACT	8
1167 - DRYWAL/PLASTR/ACOUST/INSULATION CONTR	8
1180 - GLASS & GLAZING CONTRACTORS	8
5506 - SVCS TO BLDGS & DWELLINGS, OTHER	8
3205 - REAL ESTATE APPRAISERS	8
1156 - VENDING MACHINE OPERATORS	8
8806 - .1(43) BED AND BREAKFAST 1 TO 2 ROOMS	8
2061 - RV PARKS & CAMPGROUNDS	8
3331 - EXTERMINATING & PEST CONTROL SERVICES	8
0154 - SCENIC & SIGHTSEEING TRANS, OTH	8
1708 - BRCK/STNE/RELATED CONSTR MTRLS WHLSRS	7
2070 - AUTO OIL CHANGE & LUBRICATION SHOPS	7
0028 - DIGITAL PRINTING	7
2078 - APPLIANCE REPAIR & MAINT	7
1148 - PRERECORDED TAPE, CD & RECORD STORES	7
1601 - NEW CAR DEALERS	7
4301 - R & D IN PHYS/ENGINEERG/LIFE SCIENCES	7
1141 - FOOD (HEALTH) SUPPLEMENT STORES	7
4512 - DOCUMENT PREPARATION SVCS	7
1901 - COMP/COMP PERIPH EQUIP & SFTWR WHLSRS	7
3354 - LANDSCAPE ARCHITECTURAL SVCS	7
2020 - CARPET & UPHOLSTERY CLEANING SVCS	7
0184 - OFFICES OF PODIATRISTS	6
2038 - RESIDENTIAL CARE FACILITIES, OTH	6
3343 - FREIGHT TRANS ARRANGEMENT	6
0169 - PROF & MGMT DEVELOPMENT TRAINING	6
0149 - PAINT, VARNISH & SUPPLIES WHLSRS	6
2034 - NAVIGATIONAL SVCS TO SHIPPING	6
0197 - SPECIALTY(EX PYSCH/SUBST ABUSE) HOSP	6
0118 - TRANSP EQP/SUPP (EX MOTOR VEH) WHLSRS	6
3332 - OFFICE MACH & EQUIP RENTAL & LEASING	6
1192 - ADVERTISING, OTHER SVCS RELATED TO	6
0104 - EQUIP & SUPP WHLSRS, OTH PROF	6
3358 - BUILDING INSPECTION SVCS	6
3313 - AUTOMOBILE DRIVING SCHOOLS	6
2073 - COMPUTER & OFFICE MACH R & M	6
0801 - PAWNSHOPS	6
1706 - HOME FURNISHING WHLSRS	6
2008 - USED HOUSEHOLD & OFFICE GOODS MOVING	6
1125 - HARDWARE STORES	6
2502 - TELECOMMUNICATIONS RESELLERS	5
5001 - PRIVATE MAIL CENTERS	5
0189 - FREESTAND AMBUL SURGICAL/EMERGCY CTR	5
5401 - CONVENTION & VISITORS BUREAUS	5
1604 - MOTORCYCLE DEALERS	5
1902 - MED/DENTL/HOSPITAL EQP & SUPP WHLSRS	5
1183 - WRECKING & DEMOLITION CONTRACTORS	5
3323 - ROAD TRANS SUPPORT ACTIVITIES, OTH	5
2601 - DATA PROCESSING SVCS	5
8404 - 2(14)(A) MEMBER TO CANVASS OR SOLICIT	5
1136 - OFFICE SUPPLIES & STATIONERY STORES	5
0159 - WASTE COLLECTION, OTHER	5
2045 - EMERGENCY & OTH RELIEF SVCS	5
2203 - COURIERS	5
2069 - AUTO GLASS REPLACEMENT SHOPS	5
0106 - ELEC APPR/EQP/WIR SUPP/CONSTR MAT WHL	5
1100 - JWLRY/WTCH/PREC STONE OR METAL WHLSRS	5
2035 - SCENIC & SIGHTSEEING TRANS, WATER	5
3311 - PASSENGER CAR LEASING	5
0121 - RECYCLABLE MATERIAL WHLSRS	5
2303 - PUBLISHERS, ALL OTHER	5
0137 - FRESH FRUIT & VEGETABLE WHLSRS	4
3206 - VOLUNTARY HEALTH ORG	4
0027 - COMMERCIAL SCREEN PRINTING	4
8807 - .1(43) BED AND BREAKFAST 3 TO 5 ROOMS	4
2301 - MOTION PICTURE THEATER (EX DRIVE-INS)	4
0123 - STATIONERY & OFFICE SUPPLIES WHLSRS	4
0070 - FABR METAL PRDCT MFG, ALL OTH MISC	4
2088 - SUPPORT ACTIVITIES FOR OIL/GAS OPER	4
2089 - LESSORS OF NONFNAN INTANGIBLE ASSETS	4
5504 - LOCKSMITHS	4
0105 - METAL SVC CENTERS & OFFICES	4
2401 - TELEVISION BROADCASTING	4
0110 - PLMG/HTNG EQUIP/SUPP (HYDRNCS) WHLSRS	4
2075 - ELECTRONIC & PRECISION EQP R & M, OTH	4
1165 - MASONRY & STONE CONTRACTORS	4
3601 - PROC/PHYS DISTRIB/LOGSTS CNSLTNG SVCS	4
3360 - AGT/MGR FOR ARTST/ATHL/ENTERT/PUB FIG	4
3377 - COMPUTER FACILITIES MGT SVCS	4
2036 - WATER TRANS SUPPORT ACTIVITIES, OTH	4
1133 - HIGHWAY & STREET CONSTRUCTION	4
2043 - TEMPORARY SHELTERS	4
0173 - EXAM PREPARATION & TUTORING	4
1144 - LUGGAGE & LEATHER GOODS STORES	4
1159 - OUTDOOR POWER EQUIPMENT STORES	4
2056 - CASINOS (EXC HOTEL CASINOS)	4
0145 - FARM SUPPLIES WHLSRS	4
2067 - AUTO TRANSMISSION REPAIR	4
3370 - MORTGAGE & NONMORTGAGE LOAN BROKERS	4
4504 - VIDEO GAMES/PINBALL/FLIPPER DEVICES	4
1184 - BLDG EQUIP & OTH MACH INSTALL CTRCTRS	4
3349 - AMUSEMENT ARCADES	3
5201 - COURT REPORTING & STENOTYPE SVCS	3
1186 - FLOOR COVERING STORES	3
3348 - PAYROLL SERVICES	3
1168 - TILE/MARBLE/TERRAZZ/MOSAIC CONTRACTOR	3
1611 - MOTOR VEHICLE DEALERS, ALL OTHER	3
1138 - CAMERA & PHOTOGRAPHIC SUPPLIES STORES	3
1172 - FLOOR LAYING & OTH FLOOR CONTRACTORS	3
1801 - PERISHABLE PREPARED FOOD MFG	3
2026 - GRANTMAKING FOUNDATIONS	3
1702 - MOTOR VEH SUPPLIES & NEW PARTS WHLSRS	3
1135 - HOUSEHOLD APPLIANCE STORES	3
0140 - PLASTIC MAT/BASIC FORMS/SHAPES WHLSRS	3
2030 - SPECIALIZED FREIGHT (EXC USED) TRCKNG	3
2048 - SPORTS TEAMS & CLUBS	3
4505 - ADVERTISING MATERIAL DISTRIBUTION SVCS	3
2080 - FOOTWEAR & LEATHER GOODS REPAIR	3
0156 - AIR TRANS SUPPORT ACTIVITIES, OTH	3
0131 - PACKAGED FROZEN FOOD WHLSRS	3
3329 - COMM AIR/RAIL/WTR TRANS EQP RNTL/LSNG	3
3339 - NOTARIES	3
0128 - WOMEN/CHILDREN/INFANTS CLOTHING WHLSRS	3
2093 - CREDIT INTERMED, OTH ACTIVIT RELATED	3
0171 - FLIGHT TRAINING	3
4704 - TRAVELER ACCOMMODATION, ALL OTH	3
2046 - VOCATIONAL REHABILITATION SVCS	3
3315 - CONSUMER ELECTRONICS/APPLIANCE RENTAL	3
4101 - REFRIGERATED WAREHOUSING & STORAGE	3
3902 - TEMPORARY HELP SERVICES	3
3356 - DRAFTING SERVICES	2
5507 - PACKAGING & LABELING SVCS	2
3320 - REAL ESTATE CREDIT	2
8401 - .2(10A) MANUALLY PAINT, SKETCH OR DRAW	2
3702 - DISPLAY ADVERTISING	2
3402 - LAND SUBDIVISION & LAND DVLPMT	2
8570 - 2(35)(C) PUBLIC SHOW / RETAIL SALES	2
3330 - CONSTR/MNG/FRSTRY MACH & EQP RNT/LSNG	2
4302 - R & D IN SOCIAL SCIENCES & HUMANITIES	2
3381 - SOUND RECORDING STUDIOS	2
3362 - CLAIMS ADJUSTING	2
3384 - NURSING CARE FACILITIES	2
8460 - .2(7) SELL ON FOOT OR FROM PUSH CART	2
0025 - ENVIRONMENT & WILDLIFE ORG	2
2016 - PORT & HARBOR OPERATIONS	2
1107 - COMMERCIAL EQUIPMENT WHLSRS, OTH	2
0127 - MEN/BOYS CLOTHING & FURNISHING WHLSRS	2
2076 - COMMR/IND MACH/EQP (EX AUTO/ELEC) R&M	2
0079 - SHIP BLDG & REPAIR	2
2072 - CONSUMER ELECTRONICS R & M	2
0081 - WOOD KITCHEN CABINET & COUNTERTOP MFG	2
0157 - RAIL TRANS SUPPORT ACTIVITIES	2
2058 - GOLF COURSES & COUNTRY CLUBS	2
0153 - GRANTMAKING & GIVING SVCS, OTH	2
1179 - STRUCTURAL STEEL ERECTION CONTRACTORS	2
2049 - APPAREL ACCESS & APPAREL MFG, OTH	2
0111 - WARM AIR HEATNG/A/C EQUIP/SUPP WHLSRS	2
2028 - SOLID WASTE COLLECTION	2
0115 - INDUSTRIAL MACHINERY & EQUIP WHLSRS	2
0203 - COMMERCIAL BANKING	2
2013 - MARINE CARGO HANDLING	2
0117 - SVC ESTABLISHMENT EQUIP & SUPP WHLSRS	2
2009 - ARMORED CAR SERVICES	2
2006 - COLLECTION AGENCIES	2
0134 - CONFECTIONERY WHOLESALERS	2
1711 - OFFICE EQUIP WHLSRS	2
0124 - INDUSTRIAL/PERSONAL SVC PAPER WHLSRS	2
1118 - DEPARTMENT STORES	2
0126 - PIECE GDS/NOTION/OTH DRY GOODS WHLSRS	2
1102 - FRUIT & VEGETABLE MARKETS	2
0192 - DIAGNOSTIC IMAGING CTRS	2
0198 - RESIDNTIAL MENTAL RETARDATION FACILIT	2
2817 - WMN/GIRL CUT/SEW DRESS MFG	2
2503 - PERFORMING ARTS COMPANIES, OTHER	2
2405 - PROFESSIONAL ORGANIZATIONS	2
0193 - AMBULANCE SERVICES	2
0309 - PORTFOLIO MANAGEMENT	2
2306 - INTEGRATED RECORD PRODUCTION/DISTRIB	2
2305 - RECORD PRODUCTION	2
0310 - TRUST, FIDUCIARY & CUSTODY ACTIVITIES	2
2209 - LOCAL MESSENGERS & LOCAL DELIVERY	2
0037 - SOAP & OTH DETERGENT MFG	2
0401 - SELLING STOCKS OR BONDS AS PRINCIPAL	2
0186 - FAMILY PLANNING CENTERS	2
2204 - NEWSPAPER PUBLISHERS	2
0170 - COSMETOLOGY & BARBER SCHOOLS	2
0314 - MFG & INDUSTRIAL BLDG CONSTRUCTION	2
2201 - ELECTRIC BULK PWR TRANSMISSION & CTRL	2
0148 - TOBACCO & TOBACCO PRODUCT WHLSRS	1
0132 - DAIRY PRDCT (EXC DRIED/CANNED) WHLSRS	1
0166 - COLLEGES, UNIVERSITIES & PROF SCHOOLS	1
4510 - EMPLOYEE LEASING SVCS	1
0142 - PETRO PRDCT WHLSRS(EX BLK STATN/TRML)	1
0194 - BLOOD & ORGAN BANKS	1
4507 - TRANSLATION & INTERPRETATION SVCS	1
4102 - FARM PRODUCT WAREHOUSING & STORAGE	1
0162 - REMEDIATION SERVICES	1
4401 - MEDIA BUYING AGENCIES	1
3303 - REAL ESTATE INVESTMENT TRUSTS	1
0125 - DRUGS & DRUGGISTS' SUNDRIES WHLSRS	1
8403 - 2(14)(B) MEMBER TO CANVASS/SOLICIT	1
9905 - GAMES OF SKILL OR AMUSEMENT	1
0029 - MANIFOLD BUSINESS FORMS PRINTING	1
0030 - BOOKS PRINTING	1
8804 - NURSING HOME	1
8722 - AUTHORIZED RAFFLES/GAMES OF CHANCE	1
8612 - 2(34) RUMMAGE/GARAGE SALE	1
0032 - ASPHALT PAVING MIXTURE & BLOCK MFG	1
8550 - 2(35)(A) RETAIL SALE/TEMPORARY QUARTERS	1
0035 - INDUSTRIAL GAS MFG	1
8440 - 2(31)ADMISSIONS ARE CHARGED	1
8408 - .2(6) COOKED FOODS, CAKE, PIES, ETC.	1
0043 - FINE CHINA & OTH POTTERY PRODUCT MFG	1
0122 - PRINTING & WRITING PAPER WHLSRS	1
8258 - 2(16) SELL PHOTOGRAPHS - PARTIES POSE	1
8253 - .2(9) HOME MANUFACT/HOMEMADE ARTICLES	1
0055 - SHEET METAL WORK MFG	1
0056 - ORNAMENTAL & ARCHIT METAL WRK MFG	1
0084 - CUSTOM ARCHITEC WOODWORK/MILLWORK MFG	1
0093 - JEWELRY (EXC COSTUME) MFG	1
0094 - COSTUME JEWELRY & NOVELTY MFG	1
0100 - MUSICAL INSTRUMENT MFG	1
0120 - TOY & HOBBY GOODS & SUPPLIES WHLSRS	1
4801 - TELEMARKETING BUREAUS	1
4706 - SHORT TERM RENTALS/RESIDENTIAL PROPERTIES	1
0200 - CONTINUING CARE RETIREMNT COMMUNITIES	1
0702 - DIRECT PROPTY/CASUALTY INSUR CARRIERS	1
0302 - CREDIT UNIONS	1
2092 - NEWS SYNDICATES	1
2042 - COMMUNITY FOOD SVCS	1
2053 - HISTORICAL SITES	1
2057 - GAMBLING INDUSTRIES, OTH	1
2060 - CASINO HOTELS	1
2066 - AUTO EXHAUST SYSTEM REPAIR	1
2074 - COMMUNICATION EQUIP R & M	1
2082 - DIET & WEIGHT REDUCING CENTERS	1
2083 - LINEN SUPPLIES	1
2087 - DRILLING OIL & GAS WELLS	1
3328 - RACETRACKS	1
2091 - PIPELINE TRANSPORTATION OF CRUDE OIL	1
2095 - FACILITIES SUPPORT SERVICES	1
2022 - SCHEDULED PASSENGR AIR TRANSPORTATION	1
2202 - CUT & SEW APPAREL MFG, ALL OTHER	1
2205 - PERIODICAL PUBLISHERS	1
3319 - HOME HEALTH EQUIP RENTAL	1
2206 - BOOK PUBLISHERS	1
2207 - WIRED TELECOMMUNICATIONS CARRIERS	1
3316 - FORMAL WEAR & COSTUME RENTAL	1
2208 - ON-LINE INFORMATION SVCS	1
2307 - MUSIC PUBLISHERS	1
2402 - CABLE NETWORKS	1
2504 - SATELLITE TELECOMMUNICATIONS	1
3301 - OPEN-END INVESTMENT FUNDS	1
2037 - HOMES FOR THE ELDERLY	1
2012 - COASTAL & GREAT LAKES FREIGHT TRANS	1
0303 - SALES FINANCING	1
1181 - EXCAVATION CONTRACTORS	1
0307 - COMMODITY CONTRACTS DEALING	1
0308 - COMMODITY CONTRACTS BROKERAGE	1
0311 - NATURAL GAS DISTRIBUTION	1
0601 - DIRECT HEALTH/MED INSURANCE CARRIERS	1
0602 - DIRECT TITLE INSURANCE CARRIERS	1
0604 - WATER, SEWER & PIPELINE CONSTRUCTION	1
3302 - BUSINESS ASSOCIATIONS	1
1132 - HOME CENTERS	1
1150 - NEWS DEALERS & NEWSSTANDS	1
1162 - FUEL DEALERS, OTHER	1
1163 - QUICK PRINTING	1
3367 - SURVEYING/MAPP (EX GEOPHYSICAL) SVCS	1
2007 - NONSCHED CHARTERED PASSENGR AIR TRANS	1
1182 - WINDOW TREATMENT STORES	1
1188 - CONFECT MFG FROM PURCH CHOCOLATE	1
1193 - DRIED & DEHYDRATED FOOD MFG	1
1301 - BREAD MFG	1
1603 - RECREATIONAL VEHICLE DEALERS	1
1606 - SNACK FOOD MFG, OTHER	1
1608 - FLAVORING SYRUP & CONCENTRATE MFG	1
1609 - MAYO/DRESS/OTH PREPARED SAUCE MFG	1
1710 - PHOTOGRAPHIC EQUIP & SUPPLIES WHLSRS	1
1802 - SOFT DRINK MFG	1
3351 - MRKTG RESEARCH/PUBLIC OPINION POLLING	1
9907 - ARCADES	1